﻿-- =============================================
-- Script Template
-- =============================================
SET IDENTITY_INSERT [ODTranslation].[NativeVocabulary] ON
INSERT [ODTranslation].[NativeVocabulary] ([VocabularyID], [PublisherID], [DownloadedFromURL], [DateDownloaded], [VocabularyText], [VocabularyType]) VALUES (1, 0, NULL, NULL, NULL, N'VariableCode');
INSERT [ODTranslation].[NativeVocabulary] ([VocabularyID], [PublisherID], [DownloadedFromURL], [DateDownloaded], [VocabularyText], [VocabularyType]) VALUES (2, 0, N'http://www.example.com/GetVocabulary.ashx?type=censoring', CAST(0x00009A9300000000 AS DateTime), N'<vocabularyElement>&lt;</vocabularyElement><vocabularyElement>&gt;</vocabularyElement><vocabularyElement>exact</vocabularyElement>', N'CensorCode')
INSERT [ODTranslation].[NativeVocabulary] ([VocabularyID], [PublisherID], [DownloadedFromURL], [DateDownloaded], [VocabularyText], [VocabularyType]) VALUES (3, 0, N'', CAST(0x00009BF900000000 AS DateTime), N'', N'VariableCode')
SET IDENTITY_INSERT [ODTranslation].[NativeVocabulary] OFF

INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'&lt;', 2, 50, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'&gt;', 2, 51, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'exact', 2, 49, CAST(0x00009BA400000000 AS DateTime))

--Added as part of State Climatology Office Cronos ECONET integration
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'battmin', 3, 129, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'c1sm', 3, 130, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'c1tmp', 3, 131, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'c2sm', 3, 132, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'c2tmp', 3, 133, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'c3sm', 3, 134, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'c3tmp', 3, 135, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'c4sm', 3, 136, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'c4tmp', 3, 137, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'c5sm', 3, 138, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'c5tmp', 3, 139, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'diravgwind', 3, 140, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'diravgwind02', 3, 141, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'evap', 3, 142, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'gust', 3, 143, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'gust02', 3, 144, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'gust06', 3, 145, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'gustavg', 3, 146, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'gustdir', 3, 147, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'gustmax', 3, 148, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'gustmax02', 3, 149, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'gustmaxdir', 3, 150, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'gustmaxdir02', 3, 151, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'gustmaxtime', 3, 152, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'gustmaxtime02', 3, 153, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'par', 3, 154, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'paravg', 3, 155, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'parmax', 3, 156, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'parmaxtime', 3, 157, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'precip', 3, 158, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'pres', 3, 159, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'presavg', 3, 160, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'presmax', 3, 161, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'presmaxtime', 3, 162, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'presmin', 3, 163, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'presmintime', 3, 164, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'rh', 3, 165, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'rh10', 3, 166, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'rhavg', 3, 167, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'rhavg10', 3, 168, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'rhmax', 3, 169, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'rhmax10', 3, 170, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'rhmaxtime', 3, 171, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'rhmaxtime10', 3, 172, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'rhmin', 3, 173, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'rhmin10', 3, 174, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'rhmintime', 3, 175, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'rhmintime10', 3, 176, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'sm', 3, 177, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'smavg', 3, 178, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'smmax', 3, 179, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'smmaxtime', 3, 180, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'smmin', 3, 181, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'smmintime', 3, 182, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'speedavgwind', 3, 183, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'speedavgwind02', 3, 184, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'sr', 3, 185, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'sravg', 3, 186, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'srmax', 3, 187, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'srmaxtime', 3, 188, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'st', 3, 189, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'stavg', 3, 190, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'stmax', 3, 191, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'stmaxtime', 3, 192, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'stmin', 3, 193, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'stmintime', 3, 194, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'temp', 3, 195, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'temp10', 3, 196, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'tempavg', 3, 197, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'tempavg10', 3, 198, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'tempmax', 3, 199, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'tempmax10', 3, 200, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'tempmaxtime', 3, 201, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'tempmaxtime10', 3, 202, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'tempmin', 3, 203, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'tempmin10', 3, 204, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'tempmintime', 3, 205, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'tempmintime10', 3, 206, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'wd', 3, 207, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'wd02', 3, 208, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'wd06', 3, 209, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'wdavg', 3, 210, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'wdavg02', 3, 211, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'wdmax', 3, 212, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'wdmax02', 3, 213, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'winddiravg', 3, 214, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'windsd', 3, 215, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'windsd02', 3, 216, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'ws', 3, 217, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'ws02', 3, 218, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'ws06', 3, 219, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'wsavg', 3, 220, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'wsavg02', 3, 221, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'wsmax', 3, 222, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'wsmax02', 3, 223, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'wsmaxdir', 3, 224, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'wsmaxdir02', 3, 225, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'wsmaxtime', 3, 226, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'wsmaxtime02', 3, 227, CAST(0x00009BA400000000 AS DateTime))

--Added as part of RENCI Brunswick County Flood Sensors integration
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'air_pressure', 3, 229, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'air_temp', 3, 230, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'hail_acc', 3, 231, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'hail_duration', 3, 232, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'hail_intensity', 3, 233, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'hail_peak_intensity', 3, 234, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'heating_temp', 3, 235, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'heating_voltage', 3, 236, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'qual', 3, 237, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'rain_acc', 3, 238, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'rain_duration', 3, 239, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'rain_intensity', 3, 240, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'rain_peak_intensity', 3, 241, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'ref_voltage', 3, 242, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'rel_humidity', 3, 243, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'spot_voltage', 3, 244, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'supply_voltage', 3, 245, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'water_dist', 3, 246, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'water_lev', 3, 247, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'water_temp', 3, 248, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'winddir_avg', 3, 249, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'winddir_max', 3, 250, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'winddir_min', 3, 251, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'windspeed_avg', 3, 252, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'windspeed_max', 3, 253, CAST(0x00009BA400000000 AS DateTime))
INSERT [ODTranslation].[Dictionary] ([NativeTerm], [NativeVocabularyID], [LocalTermID], [DateCreated]) VALUES (N'windspeed_min', 3, 254, CAST(0x00009BA400000000 AS DateTime))
